2014-11-09 - 10735 - Rel Notes - Program to Create Call Offs from Load File for Japan Portal Customers #SAPReleases2014

Release Notes - Draft


10735 : Program to create call offs from load file for Japan Portal Customers


Admin Info


Purpose
 Create Call offs with reference to contract item using data from file as input
Release No
 001
Submitted on
 11/14/2014
Submitted by
 Surya Basa
Environment
 NECNED to NECNEQ
Sent To
 Daniel Brennan
Object(s) created by
 Deepak Yasam, Venkat Kondapally, Karthik Vinayagam
Object(s) tested by
 Surya Basa, Siba Mohapatra
Transport Status
 Created in NECNED100

Transport and Technical Objects

Sl.
 Transport ID
 Description
 Object Name
1
 NEDK928105
 SD:10735 : Japan CallOff Creation Program
 ZJPN_CALL_OFF
ZSD_JPN_ORD_CALL_OFF
2
 NEDK928028
 SD:10735 : Japan Audit Reports For Order Upload
 Z_SO_LOAD_AUDIT
ZJCALL
3
 NEDK928107
 SD:10735:ZJ Delivery Block & Rejectn Reasn for Japan Calloff
 V_TVLS
V_TVAG
/AFS/TVAG_V

Release Notes

For Infrastructure

NA

For Requestor

NA


Test Notes

System : NECNED500


Test ID
 Scenario
 Material #
 Size
 ATP Check
 Contract Ref
 Contract Allocation
 Inventory
 Expected Results
 Actual Result
 P/F
 Doc #
 Notes
 Tested By
 QA By
JP-01
 Call offs should be
created if there's a
valid open contract
and w/o reference
when not
 Material 1
 sz1
 z2
 Single
 Full allocation
 Available
 Order line should be loaded with contract reference
 Order line loaded with reference to contract
 P
 1947659
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z2
 Single
 Full allocation
 Available
 Order line should be loaded with contract reference
 Order line loaded with reference to contract
Material 2
 sz1
 z3
 No contract
Available
 Order line should be loaded w/o contract reference
 Order line loaded w/o reference to contract
Material 2
 sz2
 z3
 No contract
Available
 Order line should be loaded w/o contract reference
 Order line loaded w/o reference to contract
Material 3
 sz1
 z2
 single
 Full allocation
 Available
 Order line should be loaded with contract reference
 Order line loaded with reference to contract
Material 3
 sz2
 z2
 single
 Full allocation
 Available
 Order line should be loaded with contract reference
 Order line loaded with reference to contract
JP-02
 Requested Delivery
Date not in range of open contracts
 Material 1
 sz2
 z2
 Single
 Not allocation
 Not available
 Order line should be loaded w/o refence to contract
because calloff RDD does not match validity of open
contract.
 Order line loaded w/o refence to contract.
No inventory. Because Calloff RDD is
greater than Contract RDD.
 P
 1947651
 NA
 Siba Mohapatra
 Surya Basa
Material 2
 sz1
 z3
 No contract
Available
 Order line should be loaded w/o contract reference
 Order line loaded w/o reference to contract
Material 2
 sz2
 z3
 No contract
Available
 Order line should be loaded w/o contract reference
 Order line loaded w/o reference to contract
Material 3
 sz1
 z2
 single
 Full allocation
 Available
 Order line should be loaded with contract reference
 Order line loaded with reference to contract
Material 3
 sz2
 z2
 single
 Full allocation
 Available
 Order line should be loaded with contract reference
 Order line loaded with reference to contract
JP-03
 Multiple Contract References
exist and z3 behaviour w/o
inventory
 Material 4
 sz1
 z2
 multiple
 Full allocation
 Available
 Order line should be loaded with 1st Contract #
& reject reason
 Order line loaded with 1st Contract #
& reject reason
Material 4
 sz2
 z2
 multiple
 Full allocation
 Available
 Order line should be loaded with 1st Contract #
& reject reason
 Order line loaded with 1st Contract #
& reject reason
 P
 1947650
 NA
 Siba Mohapatra
 Surya Basa
Material 2
 sz1
 z3
 No contract
Not available
 Order line should be loaded with J0 rejection reason
because of no inventory
 Order line loaded with J0 rejection reason
because of no inventory
JP-04
 Check behaviour across grid values
 Material 1
 sz3
 z2
 Multiple Contract
 Full allocation
 Available
 Order line should be loaded with reference to 1st
valid contract & reject reason
 Order line loaded with reference to 1st
contract & reject reason
 P
 1947648
 NA
 Siba Mohapatra
 Surya Basa
Material 2
 sz2
 z3
 No contract
Available
 Order line should be loaded without contract reference.
 Order line loaded without contract reference.
Material 3
 sz1
 z2
 single
 Full allocation
 Available
 Order line should be loaded with contract reference.
 Order line loaded with contract reference.
Material 3
 sz3
 z2
 Exists but not in RDD
 Full allocation
 Available
 Order line should be loaded without any contract
reference
 Order line loaded without any contract
reference
JP-05
 Duplicate order or repeat
JP-01; same combination of
SP, SH and PO #
 Material 1
 sz 1
 z2
 Single
 Full allocation
 Available
 Order should be loaded with delivery block at header.
Note: Repeated the Case # 1
 Order loaded with delivery block at header.
Note: Repeated
the Case # 1
 P
 1947664
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z2
 Single
 Full allocation
 Available
Material 2
 sz1
 z3
 No contract
Available
Material 2
 sz2
 z3
 No contract
Available
Material 3
 sz1
 z2
 single
 Full allocation
 Available
Material 3
 sz2
 z2
 single
 Full allocation
 Available
JP-06
 PO # blank in input file for a combination
of SP, SH, PO #
 Material 1
 sz 1
 z2
 Single
 Full allocation
 Available
 Entire order should not be loaded and error message
should be logged into Zerror table.
 Entire order not loaded and error message
logged into Zerror table.
 P
 NA
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z2
 Single
 Full allocation
 Available






Material 2
 sz1
 z3
 No contract
Available
Material 2
 sz2
 z3
 No contract
Available
JP-07
 Sold To blank in input file
for a combination of SP,
SH, PO #
 Material 1
 sz1
 z2
 Single
 Full allocation
 Available
 Entire order should not be loaded and error message
should be logged into Zerror table.
 Entire order not loaded and error message logged
into Zerror table.
 P
 NA
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z2
 Single
 Full allocation
 Available
Material 2
 sz1
 z3
 No contract
Available
Material 2
 sz2
 z3
 No contract
Available
JP-08
 Ship To blank in input file for a combination
of SP,
SH, PO#
 Material 1
 sz 1
 z2
 Single
 Full allocation
 Available
 Entire order should not be loaded and error message
should be logged into Zerror table.
 Entire order not loaded and error message logged
into Zerror table.
 P
 NA
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z2
 Single
 Full allocation
 Available
Material 2
 sz1
 z3
 No contract
Available
Material 2
 sz2
 z3
 No contract
Available
JP-09
 RDD blank or invalid in
input file for a combination
of SP, SH, PO #
 Material 1
 sz1
 z2
 Single
 Full allocation
 Available
 Entire order should not be loaded and error message
should be logged into Zerror table.
 Entire order not loaded and error message logged
into Zerror table.
 P
 NA
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z2
 Single
 Full allocation
 Available
Material 2
 sz1
 z3
 No contract
Available
Material 2
 sz2
 z3
 No contract
Available
JP-10
 Cancel date blank or Invalid
in input file for a combination
of SP, SH, PO #
 Material 1
 sz1
 z2
 Single
 Full allocation
 Available
 Entire order should not be loaded and error message
should be logged into Zerror table.
 Entire order not loaded and error message logged
into
Zerror table.
 P
 NA
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z2
 Single
 Full allocation
 Available






Material 2
 sz1
 z3
 No contract
Available
Material 2
 sz2
 z3
 No contract
Available
JP-11
 Quantity value ZERO or
blank in input file for a
combination of SP, SH, PO #
 Material 1
 sz1
 z2
 Single
 Full allocation
 Available
 Entire order should not be loaded and error message
should be logged into Zerror table.
 Entire order not loaded and error message logged
into
Zerror table.
 P
 NA
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z2
 Single
 Full allocation
 Available
Material 2
 sz1
 z3
 No contract
Available
Material 2
 sz2
 z3
 No contract
Available
JP-12
 Invalid JAN ID/ Blank in file
 Material 2
 sz1
 z3
 No contract
Available
 Entire order should not be loaded and error message
should be logged into Zerror table.
 Entire order not loaded and error message logged
into Zerror table.
 P
 NA
 NA
 Siba Mohapatra
 Surya Basa
Material 2
 sz2
 z3
 No contract
Available
JP-13
 Valid contract status
complete followed by
call off for a combination
of SP, SH, PO #
 Material 1
 sz1
 z3
 Single
 Full allocation
 Available
 Call off should be created with open quantity on the contract and the remaining should error out with log in Zerror table.
 Call off was created with open quantity on the contract and the remaining was not created and
error was logged in the Zerror table.
 P
 1947689
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z3
 Single
 Full allocation
 Available
JP-14
 Valid contract status open followed by call
off quantity greater
than open quantity
for a combination of SP, SH, PO #
 Material 1
 sz1
 z3
 Single
 Full allocation
 Available
 Entire order should be loaded with reference
to the contract with the total quantity
 Entire order was loaded.
 P
 1947690
 NA
 Siba Mohapatra
 Surya Basa
Material 1
 sz2
 z3
 Single
 Full allocation
 Available

Notes:

JP-13 - The scenario will apply only for the first load file. E.g. Contract X has 10 open quantity and the load file has 2 lines that reference this size/contract with more than 10 quantity. In this case the call offs will be created for the lines up to the full reference and the subsequent lines with a different combination of SH, PO # will error out.
Subsequent changes to the file and reload will result in standalone sales orders for this item/size w/o reference to contract.

JP-14 - The scenario will apply only for the first load file and the first occurrence of the reference. E.g. Contract X has 10 open quantity and the load file has 1 line that reference this size/contract with more than 10 quantity. In this case the call off will be created with the excess quantity than on the contract.

Load File
Load File.xlsx

System: NECNEQ100


Test ID
 Test Scenario
 Expected Results
 Actual Results
 P/F
 Documents
 Notes
 Tested By
 QA By











Reference Document (Specification or Production Support Break Fix)




Surya - 2014-11-11 - 10735 - Spec - Program to create call offs with ref to Contracts for Japan cust. portal orders